Take Home Ex 3
1. The Task
To uncover the salient patterns of the resale prices of public housing property by residential towns and estates in Singapore by using appropriate analytical visualisation techniques l
For the purpose of this study, the focus in on 3-ROOM, 4-ROOM and 5-ROOM types in 2022.
2. Data Preparation
Step 1: Load Packages
Step 2: Import Data
Step3: Filter Data for the study
Filter out the data required:
1. Room Type
2. Year 2022
Step 4: Amend Data Set
1. Convert the Month from Character to Number
2. Convert Remaining lease from Character to Number
3. Re-categorise towns into regions
4. Sort Storey Range by smallest to largest
5. Create new dataset for price/sqm
Step 5: Select the relevant columns for analysis
3. Data Analytics
3.1 Histogram of dataset
From the following histograms, we have the following findings:
- When we compare the Resale Price vs Resale Price/sqm, we notice that the Resale Price is flatter and more uneven as compared to the Resale Price/sqm, especially for the lower priced. The Resale Price/Sqm is more evenly distributed, even though it is right skewed. Thus, for further analysis, the Resale price/sqm data is preferred.
- The resale by remaining lease histogram is double-peaked. The largest number of resale have 94 years left in the lease. This is almost immediately after the HDB MOP of 5 years for a 99year lease. This group should be the newest HDB flats. The next “peak” is at 60 years. When compared to the resale by town, we can see that the these 90+yo flats mostly come from the newer towns like Sengkang and Punggol. Those with lesser remaining leases come from the more mature estates.
- We noted a trend that the older flats (with lesser remaining lease) tend to be smaller room type.
- The resale by storey is in line with the trend that Singapore do not have many flats above 21 storey.



3.2 Comparing prices by flat type
Using a violin plot, we compare the $/sqm by flat type. Thus, it can be see that the prices is driven by demand that the median price for a 3-room flat can be higher than a 5-room flat.
Thus, the prices of the flat may have a higher correlation to location (accessibility), demand for flats, affordability. 5-room flats which cost higher due to the area range may have a lower demand.
It can be noted that the Singapore housing rates are rather stable with all 3 flat types have very close median of only $100-$200 difference.

3.2 Comparing prices by flat type





